﻿USE [[#DbName#]]
GO

/*============================
 * @author [#AUTHOR#]
 * @created [#CREATED#]
 * @desc 
* ============================ */

--1.建表结构
--============================
CREATE TABLE [dbo].[[#TbName#]] (
	[#CreateTbFields#]
)

[#CreateTbExtProp#]

--2.查询表
--============================
SELECT [#TbFields#]
  FROM [[#DbName#]].[dbo].[[#TbName#]]
GO

--3.插入
--============================
INSERT INTO [[#DbName#]].[dbo].[[#TbName#]]
           ([#TbFields#])
     VALUES
           ()
GO

--INSERT INTO [[#DbName#]].[dbo].[[#TbName#]] SELECT [#FieldValue#],[#FieldValue#],[#FieldValue#],[#FieldValue#]

--4.更新
--============================
UPDATE [[#DbName#]].[dbo].[[#TbName#]]
   SET [#UpdateTbFields#]
	WHERE <搜索条件,,>
GO

--5.删除
--============================
DELETE FROM [[#DbName#]].[dbo].[[#TbName#]]
      WHERE <搜索条件,,>
GO